Here are the required fields for the state location table.
|
Field |
Type |
Length |
Notes |
|
Form |
Char |
36 |
|
|
State |
Char |
8 |
|
|
PolicyEffectiveDate |
Char |
10 |
CCYY-MM-DD |
|
PolicyWrittenDate |
Char |
10 |
CCYY-MM-DD |
|
ControllingState |
Char |
2 |
|
|
Location |
Char |
8 |
|
|
SubLocation |
Char |
8 |
|
|
LocationAddrDate |
Char |
10 |
CCYY-MM-DD |
|
TransactionEffectiveDate |
Char |
10 |
CCYY-MM-DD |
|
ProgramCd |
Char |
6 |
|
Here are the required fields for the FED table.
|
Field |
Type |
Length |
Notes |
|
FormNumber |
Char |
36 |
|
|
FormProcessingType |
Char |
1 |
|
|
EffectiveDateSourceCD |
Char |
2 |
“PE” or “PW” |
|
EffectiveDate |
Char |
10 |
CCYY-MM-DD |
|
WithdrawalDate |
Char |
10 |
CCYY-MM-DD |
© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal notices.